package com.itheima.dao;


import com.itheima.domain.Assessment;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;


import java.util.List;

/**
 * 创建时间：2020-08-21-15:52
 * 类说明：
 * 类注解：
 */
public interface PhysiqueDao {
    //体质测评查询
    @Select("select code,name,date,body,obsession,interpersonal,hesitate,anxious,hostile,terror,paranoia,mental from t_assessment")
    List<Assessment> PhysiqueFindAll();


    @Select("select code,name,date,body,obsession,interpersonal,hesitate,anxious,hostile,terror,paranoia,mental from t_assessment where code= #{code} or name=#{name} ")
    //根据姓名/档案号查询
    List<Assessment> PhysiqueConditionFindAll();


    @Delete("delete from t_assessment where id=#{id}")
    //删除
    void deletePhysique(Assessment assessment);






}
